| 1. | A log chain starts with a full backup of the database 日志链以完整数据库备份开始。 |
| 2. | A continuous sequence of log backups is called a log chain 连续的日志序列称为“日志链” |
| 3. | Log chain a continuous sequence of transaction logs for a database 日志链中的点,恢复过程中前滚在该点停止。 |
| 4. | Discusses the most important log sequence numbers for creating a log chain 讨论了用于创建日志链的最重要的日志序列号。 |
| 5. | If you switch from the full or bulk - logged recovery model to the simple recovery model , you break the backup log chain 如果从完整恢复模式或大容量日志恢复模式切换到简单恢复模式,则需要中断备份日志链。 |
| 6. | We recommend that you never use no log or truncate only to manually truncate the transaction log , because this breaks the log chain 尽管可用此选项手动截断事务日志,但是极力建议您不要这样做,因为这会将日志链断开。 |
| 7. | If a transaction log backup in this log chain is lost or damaged , you can restore only transaction logs before the missing transaction log 如果此事务日志链中的事务日志备份丢失或损坏,则您只能还原丢失的事务日志之前的事务日志。 |
| 8. | The database mirroring synchronous mode guarantees that the log chain is unaffected by a mirroring failover and that only valid log is restored 数据库镜像同步模式可以保证日志链不受镜像故障转移的影响,也可以保证只还原有效的日志。 |
| 9. | Immediately after you complete the switch to the full recovery model or bulk - logged recovery model , take a full or differential database backup to start the log chain 从简单恢复模式切换到完整模式之后,建议您:立即执行完整数据库备份或差异数据库备份。 |
| 10. | The copy - only log backup has no effect on the log chain , and other log backups behave as if the copy - only backup does not exist . for more information , see 在进行完整数据库备份或差异备份时, sql server会备份足够的事务日志,确保还原数据库时生成一个一致的数据库。 |